Level 3 Payment Information

• MasterCard version of VAT (Value Added Tax).
• Mapped to VATAlternateTaxAmount.
• For each Invoice Detail (ivd_type=product) query database with prd_key to get tax_linked_flag from oe_tax_product. If “1” then invoice detail has VAT/Alternate Tax Amount. Add these together to get full amount.

OR

• Look up destination address country in co_country. If cty_vat_flag is set then Invoice Details are VAT/Alternate Tax.
• NOTE:

  • Currently within netFORUM the only places to set VAT tax are located in Exhibits and Events.

• MasterCard version of VAT (Value Added Tax).
• Mapped to VATAlternateTaxRate.
• For each Invoice Detail look at each AdditionalInvoiceDetail and add up the prc_percent. This gets us the tax rate.

• Get Destination address (see Level 2 Destination Address), use adr_country to retrieve cty_iso_number from co_country table.

• Obtained from Level 2 Destination Zip (see Level 2 Destination Zip).

• For each Invoice Detail, if ivd_type=discount, add them up to get the full discount amount.

• Not currently supported by netFORUM, always passes $0.00.

• For each Invoice Detail, if ivd_type=shipping, add them up to get the full shipping amount..

• A specific type of tax, can also be used in Tax Type for each line item.
• For each Invoice Detail, if ivd_type=product, use prd_key to select the following from oe_tax_product:
  • tax_cty_key
  • tax_county
  • tax_city
  • tax_post_code_min
  • tax_post_code_max
• If tax_cty_key is not empty and tax_county, tax_city, tax_post_code_min, tax_post_code_max are empty, this is considered NationalTaxAmount
• If criteria is met, sum ivd_price.

• From the first InvoiceDetail use ivd_prc_prd_key to retrieve the ivw_whs_key from oe_inventory_x_warehouse. Use ivw_whs_key to get the adr_post_code where the items are being shipped from.

• From Payment façade (passed to Mapper), use inv_code.

• If invoice has VAT Tax (see Vat Tax Amount), then use the CardAcceptorID (from Level 2) as the Tax ID of the seller.

• Visa specific field for VAT, see AlternateTaxAmount

• Not currently supported by netFORUM.
• Sage-specific field
  • Can have a 'Null' value - This tag contains information about the taxes applied in specific areas, such as states, zip codes or postal codes. (Subtag examples: us-state-area, us-zip-area, us-country-area, postal-area, world-area)

• New field added to netFORUM.
• New Table added: oe_commodity_code.
• New fields added to oe_product (prd_cmo_key) and oe_product_type (ptp_cmo_key) tables.
• For the invoice detail being looked at, use the prd_cmo_key (product commodity code key) first to get the cmo_code from the oe_commodity_code table. If it is empty, use the ptp_cmo_key to get the cmo_code from the oe_commodity_code table.
• To use in iWeb, field is accessible from the product and product type profile pages.
  • When the commodity code is evaluated, the system first looks at the product for the code. If it is null, then the product type’s commodity code will be used.
• To add or change commodity codes go to the Inventory module, use Group Item Links to Find, List and Add commodity codes.

• For the invoice detail being looked at get prc_display_name from Invoice Detail.

• Set to true if ivd_type=discount, otherwise false from Invoice Detail.

• If ivd_type = discount, get ivd_price and use as Discount Rate from Invoice Detail.

• Line item number.

• Use ivd_amount_cp as Line Total from Invoice Detail.

• Use prd_code as Product Code from Invoice Detail.

• Use ivd_qty as Quantity from Invoice Detail.

• Use ivd_tax as Tax Amount from Invoice Detail.

• For each Additional Invoice Detail on the Invoice Detail sum the prc_percent field.

• Mapped to TaxType.

• New table added: oe_tax_type.

• New fields added to oe_tax_product (tax_tty_key).

• Using the prc_key get tax_tty_key from oe_tax_product joining oe_tax_product.

• If tax_tty_key is not empty get tty_code from oe_tax_type.

• To access this field in iWeb go to Tax Product Profile Page.

• To add or change Tax Types go to the Inventory Module, use Group Item Links to Find, Add, List Tax Types

• Use ivd_price from Invoice Detail.